user master;
go

--create new database
--filename should be the path of the dropbox project folder so that we all can use the same database
create database limedb 
on (name = limedbmdf, filename = 'C:\Users\Sync\Dropbox\semester 2 assignments\EC2\Project\Database\limedb.mdf', size = 1MB, maxsize= unlimited, filegrowth = 1MB) 
log on (name = limedbldf, filename = 'C:\Users\Sync\Dropbox\semester 2 assignments\EC2\Project\Database\limedb.ldf', size = 1MB, maxsize = unlimited, filegrowth = 1MB);
go

--attach attach database
--filename should be the path of the dropbox project folder so that we all can use the same database
create database limedb
on (filename = '\C:\Users\Sync\Dropbox\semester 2 assignments\EC2\Project\Databaselimedb.mdf')
for attach;






